﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="topicDataSet" targetNamespace="http://tempuri.org/topicDataSet.xsd" xmlns:mstns="http://tempuri.org/topicDataSet.xsd" xmlns="http://tempuri.org/topicDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="topicConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="topicConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.TopicTool.Properties.Settings.GlobalReference.Default.topicConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DeTaiTableAdapter" GeneratorDataComponentClassName="DeTaiTableAdapter" Name="DeTai" UserDataComponentName="DeTaiTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="topicConnectionString (Settings)" DbObjectName="topic.dbo.DeTai" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DeTai] WHERE (([id_detai] = @Original_id_detai) AND ((@IsNull_tendetai = 1 AND [tendetai] IS NULL) OR ([tendetai] = @Original_tendetai)) AND ((@IsNull_sohd = 1 AND [sohd] IS NULL) OR ([sohd] = @Original_sohd)) AND ((@IsNull_ngaykyhd = 1 AND [ngaykyhd] IS NULL) OR ([ngaykyhd] = @Original_ngaykyhd)) AND ((@IsNull_id_tochuc = 1 AND [id_tochuc] IS NULL) OR ([id_tochuc] = @Original_id_tochuc)) AND ((@IsNull_id_cndt1 = 1 AND [id_cndt1] IS NULL) OR ([id_cndt1] = @Original_id_cndt1)) AND ((@IsNull_id_cndt2 = 1 AND [id_cndt2] IS NULL) OR ([id_cndt2] = @Original_id_cndt2)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_detai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_detai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tendetai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tendetai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tendetai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tendetai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sohd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sohd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sohd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaykyhd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaykyhd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaykyhd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaykyhd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_tochuc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tochuc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_tochuc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tochuc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_cndt1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cndt1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_cndt1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cndt1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_cndt2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cndt2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_cndt2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cndt2" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DeTai] ([tendetai], [sohd], [ngaykyhd], [id_tochuc], [id_cndt1], [id_cndt2]) VALUES (@tendetai, @sohd, @ngaykyhd, @id_tochuc, @id_cndt1, @id_cndt2);
SELECT id_detai, tendetai, sohd, ngaykyhd, id_tochuc, id_cndt1, id_cndt2 FROM DeTai WHERE (id_detai = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tendetai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tendetai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sohd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaykyhd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaykyhd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_tochuc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tochuc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_cndt1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cndt1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_cndt2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cndt2" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id_detai, tendetai, sohd, ngaykyhd, id_tochuc, id_cndt1, id_cndt2 FROM dbo.DeTai</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DeTai] SET [tendetai] = @tendetai, [sohd] = @sohd, [ngaykyhd] = @ngaykyhd, [id_tochuc] = @id_tochuc, [id_cndt1] = @id_cndt1, [id_cndt2] = @id_cndt2 WHERE (([id_detai] = @Original_id_detai) AND ((@IsNull_tendetai = 1 AND [tendetai] IS NULL) OR ([tendetai] = @Original_tendetai)) AND ((@IsNull_sohd = 1 AND [sohd] IS NULL) OR ([sohd] = @Original_sohd)) AND ((@IsNull_ngaykyhd = 1 AND [ngaykyhd] IS NULL) OR ([ngaykyhd] = @Original_ngaykyhd)) AND ((@IsNull_id_tochuc = 1 AND [id_tochuc] IS NULL) OR ([id_tochuc] = @Original_id_tochuc)) AND ((@IsNull_id_cndt1 = 1 AND [id_cndt1] IS NULL) OR ([id_cndt1] = @Original_id_cndt1)) AND ((@IsNull_id_cndt2 = 1 AND [id_cndt2] IS NULL) OR ([id_cndt2] = @Original_id_cndt2)));
SELECT id_detai, tendetai, sohd, ngaykyhd, id_tochuc, id_cndt1, id_cndt2 FROM DeTai WHERE (id_detai = @id_detai)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tendetai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tendetai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sohd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaykyhd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaykyhd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_tochuc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tochuc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_cndt1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cndt1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_cndt2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cndt2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_detai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_detai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tendetai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tendetai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tendetai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tendetai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sohd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sohd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sohd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sohd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaykyhd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaykyhd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaykyhd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaykyhd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_tochuc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tochuc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_tochuc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_tochuc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_cndt1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cndt1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_cndt1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cndt1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_cndt2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cndt2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_cndt2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_cndt2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id_detai" ColumnName="id_detai" DataSourceName="topic.dbo.DeTai" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id_detai" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id_detai" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id_detai" DataSetColumn="id_detai" />
              <Mapping SourceColumn="tendetai" DataSetColumn="tendetai" />
              <Mapping SourceColumn="sohd" DataSetColumn="sohd" />
              <Mapping SourceColumn="ngaykyhd" DataSetColumn="ngaykyhd" />
              <Mapping SourceColumn="id_tochuc" DataSetColumn="id_tochuc" />
              <Mapping SourceColumn="id_cndt1" DataSetColumn="id_cndt1" />
              <Mapping SourceColumn="id_cndt2" DataSetColumn="id_cndt2" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ThanhVienTableAdapter" GeneratorDataComponentClassName="ThanhVienTableAdapter" Name="ThanhVien" UserDataComponentName="ThanhVienTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="topicConnectionString (Settings)" DbObjectName="topic.dbo.ThanhVien" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ThanhVien] WHERE (([id_thanhvien] = @Original_id_thanhvien) AND ((@IsNull_hoten = 1 AND [hoten] IS NULL) OR ([hoten] = @Original_hoten)) AND ((@IsNull_gioitinh = 1 AND [gioitinh] IS NULL) OR ([gioitinh] = @Original_gioitinh)) AND ((@IsNull_hocvi = 1 AND [hocvi] IS NULL) OR ([hocvi] = @Original_hocvi)) AND ((@IsNull_quanham = 1 AND [quanham] IS NULL) OR ([quanham] = @Original_quanham)) AND ((@IsNull_cmnd = 1 AND [cmnd] IS NULL) OR ([cmnd] = @Original_cmnd)) AND ((@IsNull_ngaycmnd = 1 AND [ngaycmnd] IS NULL) OR ([ngaycmnd] = @Original_ngaycmnd)) AND ((@IsNull_noicap = 1 AND [noicap] IS NULL) OR ([noicap] = @Original_noicap)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_dienthoai = 1 AND [dienthoai] IS NULL) OR ([dienthoai] = @Original_dienthoai)) AND ((@IsNull_sotk = 1 AND [sotk] IS NULL) OR ([sotk] = @Original_sotk)) AND ((@IsNull_nganhang = 1 AND [nganhang] IS NULL) OR ([nganhang] = @Original_nganhang)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_thanhvien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_thanhvien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hoten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hoten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hoten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hoten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gioitinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gioitinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_gioitinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gioitinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hocvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hocvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hocvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hocvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_quanham" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quanham" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_quanham" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="quanham" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cmnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cmnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cmnd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cmnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaycmnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaycmnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ngaycmnd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ngaycmnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_noicap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="noicap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_noicap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="noicap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sotk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sotk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sotk" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sotk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nganhang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nganhang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nganhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nganhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ThanhVien] ([hoten], [gioitinh], [hocvi], [quanham], [cmnd], [ngaycmnd], [noicap], [diachi], [dienthoai], [sotk], [nganhang]) VALUES (@hoten, @gioitinh, @hocvi, @quanham, @cmnd, @ngaycmnd, @noicap, @diachi, @dienthoai, @sotk, @nganhang);
SELECT id_thanhvien, hoten, gioitinh, hocvi, quanham, cmnd, ngaycmnd, noicap, diachi, dienthoai, sotk, nganhang FROM ThanhVien WHERE (id_thanhvien = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hoten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hoten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@gioitinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gioitinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hocvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hocvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@quanham" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="quanham" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cmnd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cmnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ngaycmnd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ngaycmnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@noicap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="noicap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sotk" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sotk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nganhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nganhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id_thanhvien, hoten, gioitinh, hocvi, quanham, cmnd, ngaycmnd, noicap, diachi, dienthoai, sotk, nganhang FROM dbo.ThanhVien</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ThanhVien] SET [hoten] = @hoten, [gioitinh] = @gioitinh, [hocvi] = @hocvi, [quanham] = @quanham, [cmnd] = @cmnd, [ngaycmnd] = @ngaycmnd, [noicap] = @noicap, [diachi] = @diachi, [dienthoai] = @dienthoai, [sotk] = @sotk, [nganhang] = @nganhang WHERE (([id_thanhvien] = @Original_id_thanhvien) AND ((@IsNull_hoten = 1 AND [hoten] IS NULL) OR ([hoten] = @Original_hoten)) AND ((@IsNull_gioitinh = 1 AND [gioitinh] IS NULL) OR ([gioitinh] = @Original_gioitinh)) AND ((@IsNull_hocvi = 1 AND [hocvi] IS NULL) OR ([hocvi] = @Original_hocvi)) AND ((@IsNull_quanham = 1 AND [quanham] IS NULL) OR ([quanham] = @Original_quanham)) AND ((@IsNull_cmnd = 1 AND [cmnd] IS NULL) OR ([cmnd] = @Original_cmnd)) AND ((@IsNull_ngaycmnd = 1 AND [ngaycmnd] IS NULL) OR ([ngaycmnd] = @Original_ngaycmnd)) AND ((@IsNull_noicap = 1 AND [noicap] IS NULL) OR ([noicap] = @Original_noicap)) AND ((@IsNull_diachi = 1 AND [diachi] IS NULL) OR ([diachi] = @Original_diachi)) AND ((@IsNull_dienthoai = 1 AND [dienthoai] IS NULL) OR ([dienthoai] = @Original_dienthoai)) AND ((@IsNull_sotk = 1 AND [sotk] IS NULL) OR ([sotk] = @Original_sotk)) AND ((@IsNull_nganhang = 1 AND [nganhang] IS NULL) OR ([nganhang] = @Original_nganhang)));
SELECT id_thanhvien, hoten, gioitinh, hocvi, quanham, cmnd, ngaycmnd, noicap, diachi, dienthoai, sotk, nganhang FROM ThanhVien WHERE (id_thanhvien = @id_thanhvien)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hoten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hoten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@gioitinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gioitinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hocvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hocvi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@quanham" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="quanham" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cmnd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cmnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ngaycmnd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ngaycmnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@noicap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="noicap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sotk" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sotk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nganhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nganhang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_thanhvien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_thanhvien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hoten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hoten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hoten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hoten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_gioitinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="gioitinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_gioitinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gioitinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hocvi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hocvi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hocvi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hocvi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_quanham" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quanham" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_quanham" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="quanham" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cmnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cmnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cmnd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cmnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaycmnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaycmnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ngaycmnd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ngaycmnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_noicap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="noicap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_noicap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="noicap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_diachi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_diachi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="diachi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dienthoai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dienthoai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dienthoai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sotk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sotk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sotk" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="sotk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nganhang" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nganhang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nganhang" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nganhang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id_thanhvien" ColumnName="id_thanhvien" DataSourceName="topic.dbo.ThanhVien" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id_thanhvien" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id_thanhvien" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id_thanhvien" DataSetColumn="id_thanhvien" />
              <Mapping SourceColumn="hoten" DataSetColumn="hoten" />
              <Mapping SourceColumn="gioitinh" DataSetColumn="gioitinh" />
              <Mapping SourceColumn="hocvi" DataSetColumn="hocvi" />
              <Mapping SourceColumn="quanham" DataSetColumn="quanham" />
              <Mapping SourceColumn="cmnd" DataSetColumn="cmnd" />
              <Mapping SourceColumn="ngaycmnd" DataSetColumn="ngaycmnd" />
              <Mapping SourceColumn="noicap" DataSetColumn="noicap" />
              <Mapping SourceColumn="diachi" DataSetColumn="diachi" />
              <Mapping SourceColumn="dienthoai" DataSetColumn="dienthoai" />
              <Mapping SourceColumn="sotk" DataSetColumn="sotk" />
              <Mapping SourceColumn="nganhang" DataSetColumn="nganhang" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ThueKhoanTableAdapter" GeneratorDataComponentClassName="ThueKhoanTableAdapter" Name="ThueKhoan" UserDataComponentName="ThueKhoanTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="topicConnectionString (Settings)" DbObjectName="topic.dbo.ThueKhoan" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ThueKhoan] WHERE (([id_thuekhoan] = @Original_id_thuekhoan) AND ((@IsNull_id_detai = 1 AND [id_detai] IS NULL) OR ([id_detai] = @Original_id_detai)) AND ((@IsNull_id_thanhvien = 1 AND [id_thanhvien] IS NULL) OR ([id_thanhvien] = @Original_id_thanhvien)) AND ((@IsNull_chuyende = 1 AND [chuyende] IS NULL) OR ([chuyende] = @Original_chuyende)) AND ((@IsNull_so_hd = 1 AND [so_hd] IS NULL) OR ([so_hd] = @Original_so_hd)) AND ((@IsNull_ngayky_hd = 1 AND [ngayky_hd] IS NULL) OR ([ngayky_hd] = @Original_ngayky_hd)) AND ((@IsNull_ngayketthuc_hd = 1 AND [ngayketthuc_hd] IS NULL) OR ([ngayketthuc_hd] = @Original_ngayketthuc_hd)) AND ((@IsNull_ngaynghiemthukt = 1 AND [ngaynghiemthukt] IS NULL) OR ([ngaynghiemthukt] = @Original_ngaynghiemthukt)) AND ((@IsNull_ngaythanhly_hd = 1 AND [ngaythanhly_hd] IS NULL) OR ([ngaythanhly_hd] = @Original_ngaythanhly_hd)) AND ((@IsNull_ngaygiaybiennhan = 1 AND [ngaygiaybiennhan] IS NULL) OR ([ngaygiaybiennhan] = @Original_ngaygiaybiennhan)) AND ((@IsNull_tongtien = 1 AND [tongtien] IS NULL) OR ([tongtien] = @Original_tongtien)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_thuekhoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_thuekhoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_detai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_detai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_detai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_detai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_thanhvien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_thanhvien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_thanhvien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_thanhvien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chuyende" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chuyende" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chuyende" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chuyende" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_so_hd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="so_hd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_so_hd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="so_hd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayky_hd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayky_hd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayky_hd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayky_hd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayketthuc_hd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayketthuc_hd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayketthuc_hd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayketthuc_hd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaynghiemthukt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaynghiemthukt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaynghiemthukt" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaynghiemthukt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaythanhly_hd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaythanhly_hd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaythanhly_hd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaythanhly_hd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaygiaybiennhan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaygiaybiennhan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaygiaybiennhan" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaygiaybiennhan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tongtien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tongtien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tongtien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tongtien" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ThueKhoan] ([id_detai], [id_thanhvien], [chuyende], [so_hd], [ngayky_hd], [ngayketthuc_hd], [ngaynghiemthukt], [ngaythanhly_hd], [ngaygiaybiennhan], [tongtien]) VALUES (@id_detai, @id_thanhvien, @chuyende, @so_hd, @ngayky_hd, @ngayketthuc_hd, @ngaynghiemthukt, @ngaythanhly_hd, @ngaygiaybiennhan, @tongtien);
SELECT id_thuekhoan, id_detai, id_thanhvien, chuyende, so_hd, ngayky_hd, ngayketthuc_hd, ngaynghiemthukt, ngaythanhly_hd, ngaygiaybiennhan, tongtien FROM ThueKhoan WHERE (id_thuekhoan = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_detai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_detai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_thanhvien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_thanhvien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chuyende" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chuyende" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@so_hd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="so_hd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayky_hd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayky_hd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayketthuc_hd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayketthuc_hd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaynghiemthukt" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaynghiemthukt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaythanhly_hd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaythanhly_hd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaygiaybiennhan" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaygiaybiennhan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tongtien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tongtien" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id_thuekhoan, id_detai, id_thanhvien, chuyende, so_hd, ngayky_hd, ngayketthuc_hd, ngaynghiemthukt, ngaythanhly_hd, ngaygiaybiennhan, tongtien FROM dbo.ThueKhoan</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ThueKhoan] SET [id_detai] = @id_detai, [id_thanhvien] = @id_thanhvien, [chuyende] = @chuyende, [so_hd] = @so_hd, [ngayky_hd] = @ngayky_hd, [ngayketthuc_hd] = @ngayketthuc_hd, [ngaynghiemthukt] = @ngaynghiemthukt, [ngaythanhly_hd] = @ngaythanhly_hd, [ngaygiaybiennhan] = @ngaygiaybiennhan, [tongtien] = @tongtien WHERE (([id_thuekhoan] = @Original_id_thuekhoan) AND ((@IsNull_id_detai = 1 AND [id_detai] IS NULL) OR ([id_detai] = @Original_id_detai)) AND ((@IsNull_id_thanhvien = 1 AND [id_thanhvien] IS NULL) OR ([id_thanhvien] = @Original_id_thanhvien)) AND ((@IsNull_chuyende = 1 AND [chuyende] IS NULL) OR ([chuyende] = @Original_chuyende)) AND ((@IsNull_so_hd = 1 AND [so_hd] IS NULL) OR ([so_hd] = @Original_so_hd)) AND ((@IsNull_ngayky_hd = 1 AND [ngayky_hd] IS NULL) OR ([ngayky_hd] = @Original_ngayky_hd)) AND ((@IsNull_ngayketthuc_hd = 1 AND [ngayketthuc_hd] IS NULL) OR ([ngayketthuc_hd] = @Original_ngayketthuc_hd)) AND ((@IsNull_ngaynghiemthukt = 1 AND [ngaynghiemthukt] IS NULL) OR ([ngaynghiemthukt] = @Original_ngaynghiemthukt)) AND ((@IsNull_ngaythanhly_hd = 1 AND [ngaythanhly_hd] IS NULL) OR ([ngaythanhly_hd] = @Original_ngaythanhly_hd)) AND ((@IsNull_ngaygiaybiennhan = 1 AND [ngaygiaybiennhan] IS NULL) OR ([ngaygiaybiennhan] = @Original_ngaygiaybiennhan)) AND ((@IsNull_tongtien = 1 AND [tongtien] IS NULL) OR ([tongtien] = @Original_tongtien)));
SELECT id_thuekhoan, id_detai, id_thanhvien, chuyende, so_hd, ngayky_hd, ngayketthuc_hd, ngaynghiemthukt, ngaythanhly_hd, ngaygiaybiennhan, tongtien FROM ThueKhoan WHERE (id_thuekhoan = @id_thuekhoan)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_detai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_detai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id_thanhvien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_thanhvien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@chuyende" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chuyende" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@so_hd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="so_hd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayky_hd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayky_hd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngayketthuc_hd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayketthuc_hd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaynghiemthukt" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaynghiemthukt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaythanhly_hd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaythanhly_hd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ngaygiaybiennhan" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaygiaybiennhan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tongtien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tongtien" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_thuekhoan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_thuekhoan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_detai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_detai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_detai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_detai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_id_thanhvien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_thanhvien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_thanhvien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id_thanhvien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_chuyende" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="chuyende" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_chuyende" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="chuyende" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_so_hd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="so_hd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_so_hd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="so_hd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayky_hd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayky_hd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayky_hd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayky_hd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngayketthuc_hd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngayketthuc_hd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngayketthuc_hd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngayketthuc_hd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaynghiemthukt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaynghiemthukt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaynghiemthukt" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaynghiemthukt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaythanhly_hd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaythanhly_hd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaythanhly_hd" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaythanhly_hd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ngaygiaybiennhan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ngaygiaybiennhan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ngaygiaybiennhan" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="ngaygiaybiennhan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tongtien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tongtien" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tongtien" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tongtien" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id_thuekhoan" ColumnName="id_thuekhoan" DataSourceName="topic.dbo.ThueKhoan" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id_thuekhoan" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id_thuekhoan" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id_thuekhoan" DataSetColumn="id_thuekhoan" />
              <Mapping SourceColumn="id_detai" DataSetColumn="id_detai" />
              <Mapping SourceColumn="id_thanhvien" DataSetColumn="id_thanhvien" />
              <Mapping SourceColumn="chuyende" DataSetColumn="chuyende" />
              <Mapping SourceColumn="so_hd" DataSetColumn="so_hd" />
              <Mapping SourceColumn="ngayky_hd" DataSetColumn="ngayky_hd" />
              <Mapping SourceColumn="ngayketthuc_hd" DataSetColumn="ngayketthuc_hd" />
              <Mapping SourceColumn="ngaynghiemthukt" DataSetColumn="ngaynghiemthukt" />
              <Mapping SourceColumn="ngaythanhly_hd" DataSetColumn="ngaythanhly_hd" />
              <Mapping SourceColumn="ngaygiaybiennhan" DataSetColumn="ngaygiaybiennhan" />
              <Mapping SourceColumn="tongtien" DataSetColumn="tongtien" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="topicDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="topicDataSet" msprop:Generator_UserDSName="topicDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DeTai" msprop:Generator_TableClassName="DeTaiDataTable" msprop:Generator_TableVarName="tableDeTai" msprop:Generator_TablePropName="DeTai" msprop:Generator_RowDeletingName="DeTaiRowDeleting" msprop:Generator_RowChangingName="DeTaiRowChanging" msprop:Generator_RowEvHandlerName="DeTaiRowChangeEventHandler" msprop:Generator_RowDeletedName="DeTaiRowDeleted" msprop:Generator_UserTableName="DeTai" msprop:Generator_RowChangedName="DeTaiRowChanged" msprop:Generator_RowEvArgName="DeTaiRowChangeEvent" msprop:Generator_RowClassName="DeTaiRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id_detai" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid_detai" msprop:Generator_ColumnPropNameInRow="id_detai" msprop:Generator_ColumnPropNameInTable="id_detaiColumn" msprop:Generator_UserColumnName="id_detai" type="xs:int" />
              <xs:element name="tendetai" msprop:Generator_ColumnVarNameInTable="columntendetai" msprop:Generator_ColumnPropNameInRow="tendetai" msprop:Generator_ColumnPropNameInTable="tendetaiColumn" msprop:Generator_UserColumnName="tendetai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sohd" msprop:Generator_ColumnVarNameInTable="columnsohd" msprop:Generator_ColumnPropNameInRow="sohd" msprop:Generator_ColumnPropNameInTable="sohdColumn" msprop:Generator_UserColumnName="sohd" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaykyhd" msprop:Generator_ColumnVarNameInTable="columnngaykyhd" msprop:Generator_ColumnPropNameInRow="ngaykyhd" msprop:Generator_ColumnPropNameInTable="ngaykyhdColumn" msprop:Generator_UserColumnName="ngaykyhd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="id_tochuc" msprop:Generator_ColumnVarNameInTable="columnid_tochuc" msprop:Generator_ColumnPropNameInRow="id_tochuc" msprop:Generator_ColumnPropNameInTable="id_tochucColumn" msprop:Generator_UserColumnName="id_tochuc" type="xs:int" minOccurs="0" />
              <xs:element name="id_cndt1" msprop:Generator_ColumnVarNameInTable="columnid_cndt1" msprop:Generator_ColumnPropNameInRow="id_cndt1" msprop:Generator_ColumnPropNameInTable="id_cndt1Column" msprop:Generator_UserColumnName="id_cndt1" type="xs:int" minOccurs="0" />
              <xs:element name="id_cndt2" msprop:Generator_ColumnVarNameInTable="columnid_cndt2" msprop:Generator_ColumnPropNameInRow="id_cndt2" msprop:Generator_ColumnPropNameInTable="id_cndt2Column" msprop:Generator_UserColumnName="id_cndt2" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ThanhVien" msprop:Generator_TableClassName="ThanhVienDataTable" msprop:Generator_TableVarName="tableThanhVien" msprop:Generator_TablePropName="ThanhVien" msprop:Generator_RowDeletingName="ThanhVienRowDeleting" msprop:Generator_RowChangingName="ThanhVienRowChanging" msprop:Generator_RowEvHandlerName="ThanhVienRowChangeEventHandler" msprop:Generator_RowDeletedName="ThanhVienRowDeleted" msprop:Generator_UserTableName="ThanhVien" msprop:Generator_RowChangedName="ThanhVienRowChanged" msprop:Generator_RowEvArgName="ThanhVienRowChangeEvent" msprop:Generator_RowClassName="ThanhVienRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id_thanhvien" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid_thanhvien" msprop:Generator_ColumnPropNameInRow="id_thanhvien" msprop:Generator_ColumnPropNameInTable="id_thanhvienColumn" msprop:Generator_UserColumnName="id_thanhvien" type="xs:int" />
              <xs:element name="hoten" msprop:Generator_ColumnVarNameInTable="columnhoten" msprop:Generator_ColumnPropNameInRow="hoten" msprop:Generator_ColumnPropNameInTable="hotenColumn" msprop:Generator_UserColumnName="hoten" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="gioitinh" msprop:Generator_ColumnVarNameInTable="columngioitinh" msprop:Generator_ColumnPropNameInRow="gioitinh" msprop:Generator_ColumnPropNameInTable="gioitinhColumn" msprop:Generator_UserColumnName="gioitinh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hocvi" msprop:Generator_ColumnVarNameInTable="columnhocvi" msprop:Generator_ColumnPropNameInRow="hocvi" msprop:Generator_ColumnPropNameInTable="hocviColumn" msprop:Generator_UserColumnName="hocvi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="quanham" msprop:Generator_ColumnVarNameInTable="columnquanham" msprop:Generator_ColumnPropNameInRow="quanham" msprop:Generator_ColumnPropNameInTable="quanhamColumn" msprop:Generator_UserColumnName="quanham" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cmnd" msprop:Generator_ColumnVarNameInTable="columncmnd" msprop:Generator_ColumnPropNameInRow="cmnd" msprop:Generator_ColumnPropNameInTable="cmndColumn" msprop:Generator_UserColumnName="cmnd" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngaycmnd" msprop:Generator_ColumnVarNameInTable="columnngaycmnd" msprop:Generator_ColumnPropNameInRow="ngaycmnd" msprop:Generator_ColumnPropNameInTable="ngaycmndColumn" msprop:Generator_UserColumnName="ngaycmnd" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="noicap" msprop:Generator_ColumnVarNameInTable="columnnoicap" msprop:Generator_ColumnPropNameInRow="noicap" msprop:Generator_ColumnPropNameInTable="noicapColumn" msprop:Generator_UserColumnName="noicap" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="diachi" msprop:Generator_ColumnVarNameInTable="columndiachi" msprop:Generator_ColumnPropNameInRow="diachi" msprop:Generator_ColumnPropNameInTable="diachiColumn" msprop:Generator_UserColumnName="diachi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dienthoai" msprop:Generator_ColumnVarNameInTable="columndienthoai" msprop:Generator_ColumnPropNameInRow="dienthoai" msprop:Generator_ColumnPropNameInTable="dienthoaiColumn" msprop:Generator_UserColumnName="dienthoai" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sotk" msprop:Generator_ColumnVarNameInTable="columnsotk" msprop:Generator_ColumnPropNameInRow="sotk" msprop:Generator_ColumnPropNameInTable="sotkColumn" msprop:Generator_UserColumnName="sotk" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nganhang" msprop:Generator_ColumnVarNameInTable="columnnganhang" msprop:Generator_ColumnPropNameInRow="nganhang" msprop:Generator_ColumnPropNameInTable="nganhangColumn" msprop:Generator_UserColumnName="nganhang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ThueKhoan" msprop:Generator_TableClassName="ThueKhoanDataTable" msprop:Generator_TableVarName="tableThueKhoan" msprop:Generator_TablePropName="ThueKhoan" msprop:Generator_RowDeletingName="ThueKhoanRowDeleting" msprop:Generator_RowChangingName="ThueKhoanRowChanging" msprop:Generator_RowEvHandlerName="ThueKhoanRowChangeEventHandler" msprop:Generator_RowDeletedName="ThueKhoanRowDeleted" msprop:Generator_UserTableName="ThueKhoan" msprop:Generator_RowChangedName="ThueKhoanRowChanged" msprop:Generator_RowEvArgName="ThueKhoanRowChangeEvent" msprop:Generator_RowClassName="ThueKhoanRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id_thuekhoan" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid_thuekhoan" msprop:Generator_ColumnPropNameInRow="id_thuekhoan" msprop:Generator_ColumnPropNameInTable="id_thuekhoanColumn" msprop:Generator_UserColumnName="id_thuekhoan" type="xs:int" />
              <xs:element name="id_detai" msprop:Generator_ColumnVarNameInTable="columnid_detai" msprop:Generator_ColumnPropNameInRow="id_detai" msprop:Generator_ColumnPropNameInTable="id_detaiColumn" msprop:Generator_UserColumnName="id_detai" type="xs:int" minOccurs="0" />
              <xs:element name="id_thanhvien" msprop:Generator_ColumnVarNameInTable="columnid_thanhvien" msprop:Generator_ColumnPropNameInRow="id_thanhvien" msprop:Generator_ColumnPropNameInTable="id_thanhvienColumn" msprop:Generator_UserColumnName="id_thanhvien" type="xs:int" minOccurs="0" />
              <xs:element name="chuyende" msprop:Generator_ColumnVarNameInTable="columnchuyende" msprop:Generator_ColumnPropNameInRow="chuyende" msprop:Generator_ColumnPropNameInTable="chuyendeColumn" msprop:Generator_UserColumnName="chuyende" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="so_hd" msprop:Generator_ColumnVarNameInTable="columnso_hd" msprop:Generator_ColumnPropNameInRow="so_hd" msprop:Generator_ColumnPropNameInTable="so_hdColumn" msprop:Generator_UserColumnName="so_hd" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ngayky_hd" msprop:Generator_ColumnVarNameInTable="columnngayky_hd" msprop:Generator_ColumnPropNameInRow="ngayky_hd" msprop:Generator_ColumnPropNameInTable="ngayky_hdColumn" msprop:Generator_UserColumnName="ngayky_hd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ngayketthuc_hd" msprop:Generator_ColumnVarNameInTable="columnngayketthuc_hd" msprop:Generator_ColumnPropNameInRow="ngayketthuc_hd" msprop:Generator_ColumnPropNameInTable="ngayketthuc_hdColumn" msprop:Generator_UserColumnName="ngayketthuc_hd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ngaynghiemthukt" msprop:Generator_ColumnVarNameInTable="columnngaynghiemthukt" msprop:Generator_ColumnPropNameInRow="ngaynghiemthukt" msprop:Generator_ColumnPropNameInTable="ngaynghiemthuktColumn" msprop:Generator_UserColumnName="ngaynghiemthukt" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ngaythanhly_hd" msprop:Generator_ColumnVarNameInTable="columnngaythanhly_hd" msprop:Generator_ColumnPropNameInRow="ngaythanhly_hd" msprop:Generator_ColumnPropNameInTable="ngaythanhly_hdColumn" msprop:Generator_UserColumnName="ngaythanhly_hd" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ngaygiaybiennhan" msprop:Generator_ColumnVarNameInTable="columnngaygiaybiennhan" msprop:Generator_ColumnPropNameInRow="ngaygiaybiennhan" msprop:Generator_ColumnPropNameInTable="ngaygiaybiennhanColumn" msprop:Generator_UserColumnName="ngaygiaybiennhan" type="xs:dateTime" minOccurs="0" />
              <xs:element name="tongtien" msprop:Generator_ColumnVarNameInTable="columntongtien" msprop:Generator_ColumnPropNameInRow="tongtien" msprop:Generator_ColumnPropNameInTable="tongtienColumn" msprop:Generator_UserColumnName="tongtien" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DeTai" />
      <xs:field xpath="mstns:id_detai" />
    </xs:unique>
    <xs:unique name="ThanhVien_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ThanhVien" />
      <xs:field xpath="mstns:id_thanhvien" />
    </xs:unique>
    <xs:unique name="ThueKhoan_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ThueKhoan" />
      <xs:field xpath="mstns:id_thuekhoan" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_ThueKhoan_DeTai" msdata:parent="DeTai" msdata:child="ThueKhoan" msdata:parentkey="id_detai" msdata:childkey="id_detai" msprop:Generator_UserChildTable="ThueKhoan" msprop:Generator_ChildPropName="GetThueKhoanRows" msprop:Generator_UserRelationName="FK_ThueKhoan_DeTai" msprop:Generator_ParentPropName="DeTaiRow" msprop:Generator_RelationVarName="relationFK_ThueKhoan_DeTai" msprop:Generator_UserParentTable="DeTai" />
      <msdata:Relationship name="FK_ThueKhoan_ThanhVien" msdata:parent="ThanhVien" msdata:child="ThueKhoan" msdata:parentkey="id_thanhvien" msdata:childkey="id_thanhvien" msprop:Generator_UserChildTable="ThueKhoan" msprop:Generator_ChildPropName="GetThueKhoanRows" msprop:Generator_UserRelationName="FK_ThueKhoan_ThanhVien" msprop:Generator_ParentPropName="ThanhVienRow" msprop:Generator_RelationVarName="relationFK_ThueKhoan_ThanhVien" msprop:Generator_UserParentTable="ThanhVien" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>